use payrollredux

INSERT INTO EmployeeClassification (EmployeeClassificationId,Name) VALUES ('H'  ,'Hourly')
GO
INSERT INTO EmployeeClassification (EmployeeClassificationId,Name) VALUES ('S'  ,'Salaried')
GO
INSERT INTO EmployeeClassification (EmployeeClassificationId,Name) VALUES ('C'  ,'Commissioned')
GO


INSERT INTO PaymentMethod(PaymentMethodId,Name) VALUES ('H','Hold')
GO
INSERT INTO PaymentMethod(PaymentMethodId,Name) VALUES ('M','Mail')
GO
INSERT INTO PaymentMethod(PaymentMethodId,Name) VALUES ('D','Direct')
GO


INSERT INTO PaymentSchedule(PaymentScheduleId,Name) VALUES  ('W','Weekly')
GO
INSERT INTO PaymentSchedule(PaymentScheduleId,Name) VALUES  ('M','Monthly')
GO
INSERT INTO PaymentSchedule(PaymentScheduleId,Name) VALUES  ('B','BiWeekly')
GO